
ALTER VIEW [dbo].[OTR_HeatingOilLoads]
AS
SELECT     DV.Delivery_ID, dbo.Grades.Oil_Company_Code AS PLUCode,DV.Volume,DV.TCVolume, DV.Price, DV.Amount,
           DV.Density,DV.TankTemp,DV.TS_ReceiptIssued,DV.Receipt_Number, (select top 1 Site_Number from Global_Settings) as BranchNo
                                                  
FROM       dbo.Deliveries DV 
          INNER JOIN dbo.CurrentShift ON DV.Period_ID = dbo.CurrentShift.Period_ID 
          INNER JOIN dbo.Grades ON DV.GradeID = dbo.Grades.Grade_ID
WHERE     (DV.Receipt_Type IN (44)) AND (DV.StoredInBO = 0) AND (DV.Receipt_State = 0)
       


GO


